﻿CREATE TABLE [dbo].[t_VerificationSmart] (
    [ID]               INT            IDENTITY (1, 1) NOT NULL,
    [LoanID]           INT            NOT NULL,
    [APR]              NUMERIC (4, 2) NULL,
    [FinanceCharge]    NUMERIC (7, 2) NULL,
    [AmountFinanced]   NUMERIC (7, 2) NULL,
    [TotalOfPayments]  NUMERIC (2, 1) NULL,
    [DownPayment]      SMALLINT       NULL,
    [Term]             TINYINT        NULL,
    [Payment]          NUMERIC (8, 2) NULL,
    [DueDate]          SMALLDATETIME  NULL,
    [UnpaidBalance]    NUMERIC (7, 2) NULL,
    [Warranty]         NUMERIC (6, 2) NULL,
    [WarrantyIncluded] BIT            NOT NULL,
    [GAP]              NUMERIC (6, 2) NULL,
    [GapIncluded]      BIT            NOT NULL,
    [Disability]       NUMERIC (6, 2) NULL,
    [OtherCharges]     NUMERIC (6, 2) NULL,
    [DateSigned]       SMALLDATETIME  NULL,
    [TimeOnJobY]       TINYINT        NULL,
    [TimeOnJobM]       TINYINT        NULL,
    [TimeAtResidenceY] TINYINT        NULL,
    [TimeAtResidenceM] TINYINT        NULL,
    [Salary]           INT            NULL,
    [OtherIncome]      INT            NULL,
    [Salary2]          INT            NULL,
    [TaxIncluded]      BIT            NOT NULL,
    [Tax]              NUMERIC (6, 2) NULL,
    [DocFee]           NUMERIC (6, 2) NULL,
    [DocFeeIncluded]   BIT            NOT NULL,
    [Verifier]         VARCHAR (50)   NULL,
    [StatusID]         INT            NOT NULL,
    [StatusDate]       DATETIME       NOT NULL,
    [StatusUser]       VARCHAR (32)   NOT NULL
);

